import * as vscode from 'vscode';

export function excelColumnToNumber(column: string): number {
	column = column.toLocaleUpperCase();
	let result: number = 0;
	for (let i = 0; i < column.length; i++) {
		const charCode = column.charCodeAt(i) - 64; // 'A' 的 ASCII 码是 65
		result = result * 26 + charCode;
	}
	return result;
}

export function excelColumnToNumberStr(column: string): string {
	const columnNum = excelColumnToNumber(column);
	return `${columnNum}`;
}







